class ChangeGuias < ActiveRecord::Migration
  def self.up
      add_column :guias,  :dataemissaoguia, :datetime, :null => false
      add_column :guias,  :numerocarteirabeneficiario, :integer, :null => false, :limit => 20
      add_column :guias,  :nomebeneficiario, :string, :null => false
      add_column :guias,  :operadorabeneficiario, :integer, :null => false
      add_column :guias,  :validadecarteirabeneficiario, :datetime, :nul => false
      add_column :guias,  :nomecontratadosolic, :string, :null => false
      add_column :guias,  :siglaconselhosolic, :string, :null => false
      add_column :guias,  :numeroconselhosolic, :integer, :null => false, :limit => 15
      add_column :guias,  :ufconselhosolic, :string, :null => false
      add_column :guias,  :nomecontratadoexec, :string, :null => false
      add_column :guias,  :codigoprestadornaoperadoraexec, :integer, :null => false, :limit => 20
      add_column :guias,  :numerocnesexec, :integer, :null => false, :limit => 20
      add_column :guias,  :siglaconselhoexec, :string, :null => false
      add_column :guias,  :numeroconselhoexec, :integer, :null => false, :limit => 15
      add_column :guias,  :ufconselhoexec, :string, :null => false
      add_column :guias,  :carateratendimento, :string, :null => false
      add_column :guias,  :tiposaida, :integer, :null => false
      add_column :guias,  :tipoatendimento, :integer, :null => false
      add_column :guias,  :operadora_id, :integer, :null => false
      add_column :guias,  :empresa_id, :integer, :null => false
  end

  def self.down
  end
end
